[dbo].[BAEOrderCategoryParentLookupGetorderCategoryParentId]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEOrderCategoryParentLookupGetorderCategoryParentId

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@oCatID	int	4

SQL Script

create procedure [dbo].[BAEOrderCategoryParentLookupGetorderCategoryParentId] @oCatID int as
SELECT    ocpl.OrderCategoryID, ocpl.OrderCategoryParentID, oc.Title
    FROM    OrderCategoryParentLookup AS ocpl
        INNER JOIN OrderCategory AS oc on oc.OrderCategoryID = ocpl.OrderCategoryID
    WHERE    ocpl.OrderCategoryID = @oCatID;

GO

Uses

[dbo].[OrderCategory]
[dbo].[OrderCategoryParentLookup]
dbo